﻿alter procedure [dbo].[usp_UpdateTechnicalTask]  
 @TechnicalTaskId as int,  
 @SprintId as int,  
 @Status as nvarchar(50),  
 @TaskCompletedBy as nvarchar(50),  
 @CodeReviewStatus as nvarchar(50),  
 @CodeReviewDoneBy as nvarchar(50),  
 @UserStoryId as int,  
 @UserStoryDescription as nvarchar(max), 
 @EstimatedTime  as int,
 @RemainingTime as int,
 @TotalElapsedTime as int, 
 @TimeSpent as int 
 as  
   
 update TblTechnicalTask set  
   
 SprintId=@SprintId,  
 Status=@Status,  
 TaskCompletedBy=@TaskCompletedBy,  
 CodeReviewStatus=@CodeReviewStatus,  
 CodeReviewDoneBy=@CodeReviewDoneBy,  
 UserStoryId = @UserStoryId,  
 UserStoryDescription=@UserStoryDescription,
 EstimatedTime =@EstimatedTime, 
 RemainingTime = @RemainingTime,
 TotalElapsedTime = @TotalElapsedTime,
 TimeSpent = @TimeSpent
  
 where TechnicalTaskId  = @TechnicalTaskId


